using pixolut.BizBlox;

public class StudentCollection : DOCollection
{

//START BizBlox Generated Code : Do not remove or alter this comment
//Last Updated : Friday, 30 March 2007 3:00:53 PM
//BizBlox Version : 1.2.1.0
#region "BizBlox Generated Code"


// Start BizBloxBuilder Metadata
// $Identifier = +InheritedElements
// $DoNotModify = False

    public StudentCollection() : base(new DOFactory((DataObject)new Student())) {
    }

    //to typecast your item() property
    public new Student this[int i]{
        get{
            return (Student)base[i];
        }
    }


// End BizBloxBuilder Metadata

// Start BizBloxBuilder Metadata
// $Identifier = StudentID
// $DoNotModify = False

// End BizBloxBuilder Metadata

// Start BizBloxBuilder Metadata
// $Identifier = Name
// $DoNotModify = False

// End BizBloxBuilder Metadata

// Start BizBloxBuilder Metadata
// $Identifier = Email
// $DoNotModify = False

// End BizBloxBuilder Metadata

// Start BizBloxBuilder Metadata
// $Identifier = Age
// $DoNotModify = False

// End BizBloxBuilder Metadata

// Start BizBloxBuilder Metadata
// $Identifier = +OtherElements
// $DoNotModify = False

// End BizBloxBuilder Metadata

#endregion

//END BizBlox Generated Code : Do not remove or alter this comment

	// '' -----------------------------------------------------------------------------
	// '' <summary>
	// '' Example pattern for usage of standard SQLBuilder API calls.
	// '' </summary>
	// '' <param name="name"></param>
	// '' <remarks>
	// '' </remarks>
	// '' <history>
	// '' 	[cinj]	28/07/2004	Created
	// '' </history>
	// '' -----------------------------------------------------------------------------
	public void FindByStudentName( string name ) 
	{ 
		SQLBuilder mySql = base.GetSqlBuilder(); 
		mySql.addWhere( Student.Columns.Name, name ); 
		base.Find( mySql ); 
	} 
        
        
	// '' -----------------------------------------------------------------------------
	// '' <summary>
	// '' Example use of the SearchBuilder in a finder method.
	// '' </summary>
	// '' <param name="SearchTerm"></param>
	// '' <remarks>
	// '' </remarks>
	// '' <history>
	// '' 	[cinj]	28/07/2004	Created
	// '' </history>
	// '' -----------------------------------------------------------------------------
	public void SearchByStudentName( string SearchTerm ) 
	{ 
		SQLBuilder mySql = base.GetSqlBuilder(); 
		SearchBuilder sb = new SearchBuilder( SearchTerm ); 
		mySql.addSearch( Student.Columns.Name, sb ); 
		base.Find( mySql ); 
	} 
        
}